IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tr_ProjectAlertEmails_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tr_ProjectAlertEmails_Get]
GO

CREATE PROCEDURE [dbo].[tr_ProjectAlertEmails_Get]
	@ProjectId UNIQUEIDENTIFIER
AS

SELECT 
	* 
FROM 
	tr_ProjectAlertEmail 
WHERE
	tr_ProjectAlertEmail.ProjectId = @ProjectId
ORDER BY
	Email 

